Rename a table
1) If the Database window is not activated, activate the Database window:
a) If the Database window is minimized or behind a currently active dialog box or window:
1] Select the 'Window' menu.
2] Select the name of the database. (This brings the Database window to the front.)
b) If the Database window is hidden, do one of the following:
1] If there are no other open windows, select the 'File' menu and select 'Unhide...'. (The Unhide Window dialog box appears.)
2] If there are other open windows,
a] Select the 'Window' menu and select 'Unhide...'. (The Unhide Window dialog box appears.)
b] Select the desired Database window from the 'Window' list box.
c] Choose 'OK'. (The Database window appears active on the screen.)
NOTE 1: If the 'Use Access Special Keys' check box is checked in the 'Startup' dialog box, pressing F11 can also display and activate the Database window.
NOTE 2: Make sure the table to be renamed is closed.
2) Choose the 'Tables' tab in the Database window.
3) Select the name of the table.
4) Select the 'Edit' menu and select 'Rename'. (The table name is highlighted.)
5) Enter the new name for the table.
6) Press ENTER.